#​643 — April 8, 2026

Web Version

Together with  Microsoft logo

Postgres Weekly

AWS Engineer Reports Postgres Performance Halved by Linux 7.0 — When running Postgres 17 on an ARM-based instance running the Linux 7.0 kernel (currently in RC), an engineer noticed performance fell by 49%, leading to a kernel patch to restore Linux’s default preemption mode. The kernel developer behind the initial change, however, says Postgres needs to modernize its locking instead – a big ask given Linux 7.0 is due to land later this month.

Michael Larabel (Phoronix)

💡 It's not yet definitively known if this affects x86-64 too, but initial experiments suggest it does not.

You Don’t Have To Attend All 44 Postgres Talks — POSETTE: An Event for Postgres 2026 is a free & virtual developer event on 16-18 Jun. All 44 talks stream live & will be available later. Join live to take part in discussions with speakers & attendees. Check out the schedule and mark your calendar.

Microsoft | AMD sponsor

📊 PostgresBench: A Reproducible Benchmark for Postgres Services — ClickHouse wanted to stress test and compare their managed Postgres service against the competition, so they built this benchmark system. As is common with benchmarking posts, ClickHouse tops the results, but the system is open source, so the methodology can be easily reproduced and scrutinized.

Lionel Palacin (ClickHouse)

pg_column_size(): What You See Isn't What You Get — TOAST introduces ambiguity, and Lætitia wants to patch Postgres’s docs to be more accurate about what pg_column_size really shows.

Lætitia Avrot

📘 Lift the Elephant: A Book about Scaling Beyond the Query — A 160 page PDF book that provides a mental map of what performance levers exist in Postgres, why they matter, and how to approach tuning methodically. Good for intermediate users who want a real-world playbook. It's a paid product, but can be obtained free if needed.

Alex Yarotsky

💡 We have no financial interest in this book; the author sent us a copy for review.

📄 Waiting for Postgres 19: Add UPDATE/DELETE .. FOR PORTION OF – An extension to UPDATE/DELETE to do a ‘temporal update/delete’ based on a range or multirange column. Hubert Lubaczewski

📄 Schemas in Postgres and Oracle: What's the Difference? – Similar on the surface, very different in the details. Laurenz Albe

📄 Do You Need to Tune Postgres Vacuum? – An evergreen primer to checking for bloat and tuning Postgres’ autovacuum process. Christensen and Jones (Snowflake)

📄 What is a Collation, and Why is My Data Corrupt? Shaun Thomas

📰 Classifieds

Collect real-time search data at scale with an API built for analysts, engineers, and AI teams.

RELEASES AND CODE:

Don't Let AI Touch Your Production Database: Use dryrun Instead — For many tasks, it helps if agents can see information about your database, but they don’t really need a full connection. dryrun is Radim’s new “offline-first” Postgres MCP server that lets AI agents access what they need to help you, but using a JSON snapshot rather than a connection to your live database.

Radim Marek

pgmicro: An In-Process Postgres Reimplementation — From the founder of Turso, pgmicro parses SQL using libpg_query and compiles it directly to SQLite bytecode. Ships as an npm package and CLI with a wire protocol server option for using existing Postgres clients.

Glauber Costa (Turso)

rpg: Modern Postgres Terminal Written in Rust — A psql-compatible terminal written in Rust with built-in DBA diagnostics and AI assistant. Single binary, no dependencies, cross-platform.

Nik Samokhvalov

  • pg_clickhouse v0.1.10 – Query ClickHouse databases from Postgres. Now with more compatibility improvements, like mappings for JSON/JSONB/TEXT operators as well as numerous window functions, including RANK, PERCENT_RANK, and ROW_NUMBER.

  • pg_trickle v0.16 – Declarative, automatically-refreshing materialized views. pg_ivm is another good solution in this space.

  • pgfmt 2.0 – Rust-powered Postgres-flavored SQL formatter, supporting several SQL style guides (but here's the default).

  • libpqxx 8.0 / 8.0.1 – The official C++ client API for Postgres.